Cursors provide a mechanism by which a database client iterates over the records in a database. Using cursors, the client can get, put, and delete database records. Database programmers use cursors for processing individual rows returned by the database system for a query.
Working with cursor:
Syntax:
Declare a cursor
DECLARE cursor_name CURSOR FOR SELECT ... FROM ...
Open a cursor
OPEN cursor_name
Fetch Cursor
FETCH cursor_name INTO ...
Close Cursor
CLOSE cursor_name
Liked By
Write Answer
Concept of cursor in database?
Join MindStick Community
You have need login or register for voting of answers or question.
Rajesh Goswami
09-Nov-2010Working with cursor:
Syntax:
Declare a cursor